package com.xhs.main.dao.cwb;

import com.xhs.main.entity.cwb.CwbProposer;
import com.xhs.main.entity.cwb.CwbProposered;

import java.util.List;

public interface CwbProposeredDao {

    void insertCwbProposered(CwbProposered cwbProposered);

    //查询所有的申请数据
    List<CwbProposered> selectAllCwbProposered();

    CwbProposered selectOneByID(Integer cwbPId);

    //分页查询
    List<CwbProposered> selectAllCwbProposeredByLimit(Integer page,Integer limit);

    //模糊查询
    List<CwbProposered> selectByCondition(String employeeID,String applyType,String people,String department,Integer page,Integer limit);

    //全部未通过的审批信息
    List<CwbProposered> selectAllNoCwbProposered();

    //分页查询(未通过的审批信息)
    List<CwbProposered> selectAllNoCwbProposeredByLimit(Integer page,Integer limit);

    //模糊查询(未通过的审批信息)
    List<CwbProposered> selectByNoCondition(String employeeID,String applyType,String people,String department,Integer page,Integer limit);
    //部门经费申请汇总
    Double selectAllMoney();

    //待处理的税务
    Integer selectAllOpr();

    //未处理的税务
    Integer selectAllNoOpr();
}
